UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BkoeZUaPBYENLOstG1uA3/g3aui0kEw9xLF0ruOBCng='
WHERE
key_id = 'dc67ee25f84d03bf19f2cbbdf25644398d1778f8afd8a6043efff135f05d8972'
AND (
token = 'BkoeZUaPBYENLOstG1uA3/g3aui0kEw9xLF0ruOBCng='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)