UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gfYc9Nt3zKiMVLQirYqG4oCXLDAPi0H9FwCADAIZNeo='
WHERE
key_id = 'f19459ff6bbecf47e90d70ae8f9c018a16a150fb3219fc5f68705dbf2e4e664e'
AND (
token = 'gfYc9Nt3zKiMVLQirYqG4oCXLDAPi0H9FwCADAIZNeo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)