UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HiFhaVH0+vIf724jUF0VYTo/9R2kFJEKgTBXKtHHooI='
WHERE
key_id = '497b563d81faaa095a1220f9993e38ec0eddb8e1228157a9e2985ab2e3d29ace'
AND (
token = 'HiFhaVH0+vIf724jUF0VYTo/9R2kFJEKgTBXKtHHooI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)