UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/DcGDojE7N3ZihaFtCqjXVM7QE6ZHNvwFUANSVaw/XI='
WHERE
key_id = '00309d14ec1c1b32d0443f109a36ff8e6bb970ab3031bf92f3555a62a38d6183'
AND (
token = '/DcGDojE7N3ZihaFtCqjXVM7QE6ZHNvwFUANSVaw/XI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)