UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bz+3oiWmZe3TPjjontYeh7Rm4SHZVf5ohMtOx1wkcHc='
WHERE
key_id = 'd1b4fc949bbfa5843c72c67ba92533e31516c13cfc7b53029ca8e37f5512e8ad'
AND (
token = 'Bz+3oiWmZe3TPjjontYeh7Rm4SHZVf5ohMtOx1wkcHc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)