UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7ns237iqEMI7mN0HbyThFfmazvw3v+cn0OTxvy/TeSg='
WHERE
key_id = 'bb9808d4121a87a5c7bd1e5ba45fc7bc84957d058b77d07155ea20f7ef3762b5'
AND (
token = '7ns237iqEMI7mN0HbyThFfmazvw3v+cn0OTxvy/TeSg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)