UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cZY5dcuFXNb5be0xZzlNsaffKiJbNi99kkirvIMCIcY='
WHERE
key_id = '31d0e4630c948a4746d048555f376b2526dd113ef7d5d93ac438c7c21e97e7a0'
AND (
token = 'cZY5dcuFXNb5be0xZzlNsaffKiJbNi99kkirvIMCIcY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)