UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+9alA0DrJwCzwQZo7bBg/h3wKb4iL5Nd90LiNarnG18='
WHERE
key_id = '5056ef56cb27a12441eb148bfc4f7f5d217771847912462d22c171144654ae03'
AND (
token = '+9alA0DrJwCzwQZo7bBg/h3wKb4iL5Nd90LiNarnG18='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)