UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6iWKsbgtEXk9v1hoHVUp3s2BDh88YKXbArHupv4RhLA='
WHERE
key_id = '7a7b65a0c30245cb51fc6eac8d7ea5e28a3d7434b27c7b15f2db2daba934554e'
AND (
token = '6iWKsbgtEXk9v1hoHVUp3s2BDh88YKXbArHupv4RhLA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)