UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9bhtLKhJxwSuACzZz2MN2eO39ejVDmvdZM1ov4UWRFk='
WHERE
key_id = 'bc2bd2856a99bb5c3073dc89ce5d4c8baa996e950c5e5a3958fc7a060d6ef64d'
AND (
token = '9bhtLKhJxwSuACzZz2MN2eO39ejVDmvdZM1ov4UWRFk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)