UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2Bp7Pp0Jx9tJnywB8monT2qABUiXhVEjdDoPQnREv3g='
WHERE
key_id = '9724760b36a3004cf93467fae162af68e1b440acf0b5bf95dbe7447a6cd46204'
AND (
token = '2Bp7Pp0Jx9tJnywB8monT2qABUiXhVEjdDoPQnREv3g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)