UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xfhgxubp3NaY1XnWm4zAtxQkk/kUySErwdIpjVckpFw='
WHERE
key_id = '9ddc9767bd5d050260e1d22c7de3eeb8f1d8f51b20808ec42553e29d5f4edea7'
AND (
token = 'Xfhgxubp3NaY1XnWm4zAtxQkk/kUySErwdIpjVckpFw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)