UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lpfA2qOAq+S/jCZfFfmEEdZ8Tuyzqjacji8mSThr3yM='
WHERE
key_id = 'f08693257b75248870268c899fcac467eb91d6a14963d4c33b244901fd2447f9'
AND (
token = 'lpfA2qOAq+S/jCZfFfmEEdZ8Tuyzqjacji8mSThr3yM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)