UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2uTWq3lFAD1yje/u1VC1R8McvSXLobdogYCiDhlHRmo='
WHERE
key_id = '8fa29a1ab48c6ef0d168b893c29deb934a319b38988561004818a916c04a40a7'
AND (
token = '2uTWq3lFAD1yje/u1VC1R8McvSXLobdogYCiDhlHRmo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)