UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BXQ0lcMQDWb7AA1xEkRn71jJgb90Qo/r56BEHkbLSxk='
WHERE
key_id = '54cfb8bc5df3b6c0fb9b0e9031857423cc5e2251e9abf4fa4be7d768321a0b7d'
AND (
token = 'BXQ0lcMQDWb7AA1xEkRn71jJgb90Qo/r56BEHkbLSxk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)