UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fO0naf05YejAbYNYo7M+XE2bfvEmdfMfJ9ojyXeiq+E='
WHERE
key_id = '6d4f3d4feb28cd120a138599833d6a0363cefd807749a902e6f2a62958dc635a'
AND (
token = 'fO0naf05YejAbYNYo7M+XE2bfvEmdfMfJ9ojyXeiq+E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)