UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EOZO041OV1uEBDwA7DiGc5t/zcsuA0rMpkRIh+9ejk0='
WHERE
key_id = 'a91d47f924dc0ab426169652678ae9b0b982ae3f8fb80c760f3f53eef3312c5d'
AND (
token = 'EOZO041OV1uEBDwA7DiGc5t/zcsuA0rMpkRIh+9ejk0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)