UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kZ42fUbeb1VA6k4dR9ZNHX26yntLKrbYOUo0qRbqgV0='
WHERE
key_id = 'c7e13ba2e469241cb8d898cd27d5a6b9057e044e6c2fac292e92e9dbc6fd54d8'
AND (
token = 'kZ42fUbeb1VA6k4dR9ZNHX26yntLKrbYOUo0qRbqgV0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)