UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QhsiyMWGkjcoNRIldGqjvTZKlsM3Khz9mt32dfGEphE='
WHERE
key_id = 'eeda5692df39898123e938f8ba56c046cac46413c97f8bf305f9d80626a12506'
AND (
token = 'QhsiyMWGkjcoNRIldGqjvTZKlsM3Khz9mt32dfGEphE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)