UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'heuE1XqlUQkY+BJlECnxEl04BIKMJYBwBMP6gpXNTsU='
WHERE
key_id = 'f8a1a6aff4e677bd826b801d43fc5c2479ab1396c59b6e9998f2308bb93e2178'
AND (
token = 'heuE1XqlUQkY+BJlECnxEl04BIKMJYBwBMP6gpXNTsU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)