UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5Q8b+IAYWplHLloMVHLaFRvLG406BqdpLhkf1QGZwUY='
WHERE
key_id = '472d023b61e880bb9017e15e23dabf42a37c384e93155a5653eae20f40bc7bbf'
AND (
token = '5Q8b+IAYWplHLloMVHLaFRvLG406BqdpLhkf1QGZwUY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)