UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pTjZUG4lpsB4R8bYl5mWF1ytM5JM3uNwRVKYBuQUDrk='
WHERE
key_id = '1919ee526957ff72ffaf7afb109ad709bcae79a0ba9458509de62fef98d09a94'
AND (
token = 'pTjZUG4lpsB4R8bYl5mWF1ytM5JM3uNwRVKYBuQUDrk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)