UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o3JUZ1PTB6J4Iv5Cp+/E+tMfE+ZSN/kX7cckcz/p2jA='
WHERE
key_id = '424eff1653853f46ed70e1413b20cf9c01821abcd324b004a75464282a4911bb'
AND (
token = 'o3JUZ1PTB6J4Iv5Cp+/E+tMfE+ZSN/kX7cckcz/p2jA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)