UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e7QMwonVv9vJivY5yLKiWRfOHxQNVBPnBkMaVykNCPc='
WHERE
key_id = 'c582fc0b7ef93e507210c5bf2687b0393a439217627b36bccc679151b86f75fc'
AND (
token = 'e7QMwonVv9vJivY5yLKiWRfOHxQNVBPnBkMaVykNCPc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)