UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bv3yX9a/hb1jZJw1nsXO3VmpAm4XgpLEQxGM1Cc1awQ='
WHERE
key_id = 'b07686299238d674f47e7991fedf14248d561e325d52bc182f5f65031ec1167c'
AND (
token = 'bv3yX9a/hb1jZJw1nsXO3VmpAm4XgpLEQxGM1Cc1awQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)