UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6pk15VYODjZefgpECPOQLntbz1Z5oLvAjblXFghqfms='
WHERE
key_id = '72d521694f5f9746adfdae3e8add409a4f7d9e41a0621aed69cf4c3e9a04d504'
AND (
token = '6pk15VYODjZefgpECPOQLntbz1Z5oLvAjblXFghqfms='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)