UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L1PRr8VaHzpuxi8TnxjwTjYB4uDHKf3Trpk9TyHA8lk='
WHERE
key_id = '473cca9b191ee2e980cbb79cac76e326afb349f1e32a512598b125856545d7ec'
AND (
token = 'L1PRr8VaHzpuxi8TnxjwTjYB4uDHKf3Trpk9TyHA8lk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)