UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Kr7QWqEK3faN46WNI7K+pOXT9s9kDEJI+waT+ulkT20='
WHERE
key_id = 'bcdd1f5e1b4388f85a0c3d176a34832af2922546a236d35d0baab82454f61e5e'
AND (
token = 'Kr7QWqEK3faN46WNI7K+pOXT9s9kDEJI+waT+ulkT20='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)