UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ApW58RgMSvuiRMkOxW7n4lv+WszTN3OYibKNmh8sEyk='
WHERE
key_id = 'bdb7b2b8639bbd5aa6283e786713eee3a5bde265d9e0da492dcfafe7cec4692a'
AND (
token = 'ApW58RgMSvuiRMkOxW7n4lv+WszTN3OYibKNmh8sEyk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)