UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XpHXVX9Ins1nwllc6+KhDFLYNd+jrgMbHqY5zzXAYCM='
WHERE
key_id = '581f87e44dbab76318fe6bd3dd8754a73a320302279062145d19098f328aa254'
AND (
token = 'XpHXVX9Ins1nwllc6+KhDFLYNd+jrgMbHqY5zzXAYCM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)