UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QR1UAyT/plBKhlSQu/FIHsoNNoE9uqmIIGLBQFYcrnY='
WHERE
key_id = 'd8d9d7f99ba447ec09f546c509233da1e8be87f00b3c518d464ddb1dbcb08aa5'
AND (
token = 'QR1UAyT/plBKhlSQu/FIHsoNNoE9uqmIIGLBQFYcrnY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)